CREATE TABLE [dbo].[Stored_List]
(
[ListName] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_ListName] DEFAULT (''),
[NumberSequence] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Stored_List_NumberSequence] DEFAULT ((0)),
[DateCreated] [datetime] NULL,
[CreatedBy] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_CreatedBy] DEFAULT (''),
[Expires] [datetime] NULL,
[PrintProcedure] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_PrintProcedure] DEFAULT (''),
[ReportOptions] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_ReportOptions] DEFAULT (''),
[ListType] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_ListType] DEFAULT (''),
[Heading] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_Heading] DEFAULT (''),
[ObsoleteMenuKey] [varchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_ObsoleteMenuKey] DEFAULT (''),
[ListObject] [image] NULL,
[ShowPrint] [bit] NOT NULL CONSTRAINT [DF_Stored_List_ShowPrint] DEFAULT ((0)),
[ShowSpread] [bit] NOT NULL CONSTRAINT [DF_Stored_List_ShowSpread] DEFAULT ((0)),
[ShowGraph] [bit] NOT NULL CONSTRAINT [DF_Stored_List_ShowGraph] DEFAULT ((0)),
[Bool4] [bit] NOT NULL CONSTRAINT [DF_Stored_List_Bool4] DEFAULT ((0)),
[Bool5] [bit] NOT NULL CONSTRAINT [DF_Stored_List_Bool5] DEFAULT ((0)),
[Bool6] [bit] NOT NULL CONSTRAINT [DF_Stored_List_Bool6] DEFAULT ((0)),
[ImisSystem] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_ImisSystem] DEFAULT (''),
[Category] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_Category] DEFAULT (''),
[Title] [varchar] (45) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_Title] DEFAULT (''),
[Field1] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_Field1] DEFAULT (''),
[Field2] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_Field2] DEFAULT (''),
[Field3] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_Field3] DEFAULT (''),
[Field4] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_Field4] DEFAULT (''),
[Field5] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_Field5] DEFAULT (''),
[Field6] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_Field6] DEFAULT (''),
[field7] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_field7] DEFAULT (''),
[Field8] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_Field8] DEFAULT (''),
[DateLastRun] [datetime] NULL,
[BatchNumber] [int] NOT NULL CONSTRAINT [DF_Stored_List_BatchNumber] DEFAULT ((0)),
[NRDS_Indicator] [bit] NOT NULL CONSTRAINT [DF_Stored_List_NRDS_Indicator] DEFAULT ((0)),
[Office_Validation] [bit] NOT NULL CONSTRAINT [DF_Stored_List_Office_Validation] DEFAULT ((0)),
[Member_Validation] [bit] NOT NULL CONSTRAINT [DF_Stored_List_Member_Validation] DEFAULT ((0)),
[Alternate_Check] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Stored_List_Alternate_Check] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iStored_ListExpires] ON [dbo].[Stored_List] ([Expires]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iStored_ListListName] ON [dbo].[Stored_List] ([ListName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iStored_ListListType] ON [dbo].[Stored_List] ([ListType]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iStored_ListNumberSequence] ON [dbo].[Stored_List] ([NumberSequence]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Stored_List] TO [IMIS]
GRANT SELECT ON  [dbo].[Stored_List] TO [IMIS]
GRANT INSERT ON  [dbo].[Stored_List] TO [IMIS]
GRANT DELETE ON  [dbo].[Stored_List] TO [IMIS]
GRANT UPDATE ON  [dbo].[Stored_List] TO [IMIS]
GO